Data Stores

In 1Validate, a data store describes where some external spatial data is being read from or written to.

This represents the data which will be analysed by Rules within 1Validate.

The data store can be:

  • Automatically supported formats such as Oracle Spatial databases (with or without workspaces enabled), Esri Shapefile, MapInfo Tab files.

  • Other data formats via an FME Desktop integration (requires an FME Desktop licence).

    Formats available include file formats (e.g. Bentley DGN) and database formats (e.g. PostGIS). See Supported Data Store Types.

  • Other data formats available via project-specific bespoke data stores.

When running a session using a data store, the data is stored in the cache (see Session Cache).

Note: Names of classes and properties in 1Validate can contain any ISO 8859 characters. Unicode is not supported.

Note: All lengths, areas, and co-ordinates used in 1Validate are in dataset units (the co-ordinate system used in the external data source). 1Validate does not perform any automatic co-ordinate conversions.

Supported Data Store Types

1Validate supports the following types of datastores for input (reading) and output (writing), either as standard or using FME Desktop (which requires a licence):

Note: All formats listed below as using FME Desktop require FME Desktop Professional Edition, unless otherwise indicated.

Data Store Type As standard Using FME Desktop
Read Write Read Write

Bentley Microstation Design (V8)

Comma Separated Value (CSV)

Autodesk AutoCAD DWG/DXF

Esri Enterprise Geodatabase

1 2

Esri File Geodatabase

Esri Shapefile

MapInfo Tab

Microsoft SQL Server Spatial

3

Oracle

PostGIS

Commit / Copy-To Support

Not all data store types support the Commit task as a method of writing data back to a data store (see Commit Task). However, all data store types support the Copy-To task (see Copy To Task).

Data Store Type Task Supported
Commit Copy-To

Bentley Microstation Design (V8)

Comma Separated Value (CSV)

Autodesk AutoCAD DWG/DXF

Esri Enterprise Geodatabase

Esri File Geodatabase

Esri Shapefile

MapInfo Tab

Microsoft SQL Server Spatial

Oracle

PostGIS